---
title: "sp73089_get_policy_bound_flag stored procedure documentation"
summary: "Analysis of the sp73089_get_policy_bound_flag Oracle function including business rules and operations."
status: draft
owner: "SAIF Corporation"
last_reviewed: 2026-08-31
source_schema: "WCIS_DBA"
source_name: "sp73089_get_policy_bound_flag"
source_type: "PROCEDURE"
retrieval_status: "found"
retrieval_command: "legends oracle query --name sp73089_get_policy_bound_flag"
retrieval_date: "2026-08-31"
---

# sp73089_get_policy_bound_flag

## Overview

| Field | Value |
| --- | --- |
| **Schema** | `WCIS_DBA` |
| **Type** | Standalone function |
| **Database** | Oracle |
| **Status** | ✅ `found` — retrieved via Legends CLI |
| **Query executed** | `legends oracle query --name sp73089_get_policy_bound_flag` |
| **Calling libraries** | `SAIF.Business.View.Policy` |
| **Calling classes** | `clsPolicyData` |

## Purpose

`sp73089_get_policy_bound_flag` returns a `Y`/`N` flag indicating whether coverage is bound for a
policy period, called by the Business Online ViewPolicy Summary page per an in-source comment
(JERTOD, 02/06/2007).

## Procedures / Methods

### sp73089_get_policy_bound_flag

| Field | Value |
| --- | --- |
| **Returns** | `VARCHAR2` (function return value) |
| **Called by** | `clsPolicyData` bound-flag retrieval (`clsPolicyData.vb:1756-1765`, SQL at `2326`) |

**Description:** Delegates the coverage-bound decision to the shared bound-check procedure,
`sp72325_chk_if_policy_bound` (out of catalog scope, not retrieved separately) (see rule PR-BVP-012 in
[Business Rules](#business-rules) below).

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `in_policy_num` | IN | `NUMBER` | — | Policy number |
| `in_policy_period_eff_date` | IN | `DATE` | — | Period effective date |
| *(return)* | RETURN | `VARCHAR2` | — | `Y` / `N` |

## Business Rules

Rules extracted from this function's logic:

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| PR-BVP-012 | Coverage-bound indicator is delegated to the shared bound check | `sp72325_chk_if_policy_bound(in_policy_num, in_policy_period_eff_date)` is true | Return `'Y'`; otherwise `'N'`. Caller sets `CoverageBoundFlag = True` only on `'Y'` (`clsPolicyData.vb:1756-1765`) |

> These rules are documented in [business-rules.md](../business-rules.md).

## Operations

Operations and processes implemented in this function:

| Operation | Description | Trigger |
| --- | --- | --- |
| Check coverage bound | Returns `Y`/`N` indicating whether coverage is bound for a policy period | `clsPolicyData` bound-flag retrieval (`clsPolicyData.vb:1756-1765`, SQL at `2326`) |

> These operations are also listed in [operations-processes.md](../operations-processes.md) with source reference back to this document.

## Source Code

<details>
<summary>PL/SQL function (specification and body)</summary>

```sql
-- Called by Business Online - ViewPolicy Summary page
-- JERTOD 02/06/2007
FUNCTION sp73089_get_policy_bound_flag (in_policy_num             IN NUMBER,
                                        in_policy_period_eff_date IN DATE)
   RETURN VARCHAR2
IS
BEGIN
   IF sp72325_chk_if_policy_bound (in_policy_num, in_policy_period_eff_date)
   THEN
      RETURN 'Y';
   ELSE
      RETURN 'N';
   END IF;
END;
```

Call site (`clsPolicyData.vb:2326`):

```sql
Select sp73089_get_policy_bound_flag(:in_policy_num, :in_policy_period_eff_date) from dual
```

</details>

## Related Documentation
- [Procedure catalog](index.md)
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)

## Sources
- Oracle DBA_SOURCE: `WCIS_DBA.sp73089_get_policy_bound_flag`
- Legends CLI query executed 2026-08-31: `legends oracle query --name sp73089_get_policy_bound_flag`
- Calling code: `SAIF.Business.View.Policy/clsPolicyData.vb:1756-1765, 2326`